<?php
    require_once("core/functions.php");
    core::getResource("Controller.LoginController");
    session_start();
?>
<?php $title = "Help"; ?>
<?php include_once("header.php"); ?>
<div class="centerContent">
    <style>
        .firstLevel {
            margin-left: 1em;
        }
        .secondLevel {
            margin-left: 2em;            
        }
        .thirdLevel {
            margin-left: 3em;            
        }
    </style>
    <h1>Help</h1>
    <p>Intended Audience
        The intended audience for this manual are the administrators of the Event Management System. This manual may also be used by future developers who are updating or maintaining the system.
    </p>
    <p>
    <h3>Terms Used</h3>
    <b>EMS:</b> Event Management System<br/>
    <b>Events:</b> Events represent real world events<br/>
    <b>Activities:</b> Activities are tasks that are part of an event, such as selling tickets.<br/>
    <b>Roles:</b> Roles are individual roles of an activity, such as Manager, Assistant, etc.<br/>
    <b>Volunteer:</b> A registered user of the system<br/>
    <b>SPROUTs:</b> Paid Volunteers<br/>
    <b>Event Manager:</b> A user who manages events<br/>
    <b>Administrator:</b> A user who can do everything an Event Manager can do, as well as manage the system itself.<br/>
</p>
<h2>Index</h2>

<a href="#1" class="firstLevel">1. Introduction</a><br/>
<a href="#2" class="firstLevel">2. Installation</a><br/>
<a href="#3" class="firstLevel">3. Pages</a><br/>
<a href="#3.1" class="secondLevel">3.1. All Users</a><br/>
<a href="#3.1.1" class="thirdLevel">3.1.1. Home Page</a><br/>
<a href="#3.1.2" class="thirdLevel">3.1.2. Timetable Page</a><br/>
<a href="#3.1.3" class="thirdLevel">3.1.3. Registration Page</a><br/>
<a href="#3.1.4" class="thirdLevel">3.1.4. Events Page</a><br/>
<a href="#3.1.5" class="thirdLevel">3.1.5. Activities Page</a><br/>
<a href="#3.1.6" class="thirdLevel">3.1.6. Roles Page</a><br/>
<a href="#3.1.7" class="thirdLevel">3.1.7. Mailing List</a><br/>
<a href="#3.1.8" class="thirdLevel">3.1.8. Contact Page</a><br/>
<a href="#3.2" class="secondLevel">3.2. Volunteers, Event Managers, Administrators</a><br/>
<a href="#3.2.1" class="thirdLevel">3.2.1. Application Page</a><br/>
<a href="#3.2.2" class="thirdLevel">3.2.2. Account Dashboard Page (Revise)</a><br/>
<a href="#3.2.3" class="thirdLevel">3.2.3. Account Information Page</a><br/>
<a href="#3.2.4" class="thirdLevel">3.2.4. Change Password Page</a><br/>
<a href="#3.2.5" class="thirdLevel">3.2.5. University Page</a><br/>
<a href="#3.2.6" class="thirdLevel">3.2.6. Others Page</a><br/>
<a href="#3.2.7" class="thirdLevel">3.2.7. Applied Page</a><br/>
<?php
    if($loggedIn){
        if($page->hasAccess())
        {
            
?>
<a href="#3.3" class="secondLevel">3.3. Event Managers, Administrators</a><br/>
<a href="#3.3.1" class="thirdLevel">3.3.1. Back-End Events Page</a><br/>
<a href="#3.3.2" class="thirdLevel">3.3.2. Back-End Activities Page</a><br/>
<a href="#3.3.3" class="thirdLevel">3.3.3. Back-End Roles Page</a><br/>
<a href="#3.3.4" class="thirdLevel">3.3.4. Applications Page</a><br/>
<a href="#3.3.5" class="thirdLevel">3.3.5. Add/Remove Volunteer from Role</a><br/>
<a href="#3.3.6" class="thirdLevel">3.3.6. View Event Report</a><br/>
<a href="#3.3.7" class="thirdLevel">3.3.7. Account Information</a><br/>
<a href="#3.3.8" class="thirdLevel">3.3.8. Reset Password</a><br/>
<a href="#3.3.9" class="thirdLevel">3.3.9. Back-End University</a><br/>
<a href="#3.3.10" class="thirdLevel">3.3.10. Back-End Others</a><br/>
<a href="#4" class="firstLevel">4. Functional Walkthrough</a><br/>
<a href="#4.1" class="secondLevel">4.1. Creating events</a><br/>
<a href="#4.2" class="secondLevel">4.2. Creating Activities</a><br/>
<a href="#4.3" class="secondLevel">4.3. Creating Roles</a><br/>
<a href="#4.4" class="secondLevel">4.4. Creating user accounts(Volunteers, Event Managers, Admins)</a><br/>
<a href="#4.5" class="secondLevel">4.5. Applying to Roles</a><br/>
<a href="#4.6" class="secondLevel">4.6. Viewing Applications</a><br/>
<a href="#4.7" class="secondLevel">4.7. Allocating Volunteers to Roles</a><br/>
<a href="#4.8" class="secondLevel">4.8. De-Allocate Volunteer from Role</a><br/>
<a href="#4.9" class="secondLevel">4.9. Editing User Accounts</a><br/>
<a href="#4.10" class="secondLevel">4.10. Deleting User Accounts</a><br/>
<a href="#4.11" class="secondLevel">4.11. Edit USer Account Type</a><br/>
<a href="#4.12" class="secondLevel">4.12. Delete Event</a><br/>
<a href="#4.13" class="secondLevel">4.13. Delete Activity</a><br/>
<a href="#4.14" class="secondLevel">4.14. Delete Role</a><br/>
<a href="#4.15" class="secondLevel">4.15. View Event Report</a><br/>
<a href="#5" class="firstLevel">5. Support Diagrams</a><br/>
<a href="#5.1" class="secondLevel">5.1. ERD</a><br/>
<a href="#5.2" class="secondLevel">5.2. Class Diagram</a><br/>
<a href="#6" class="firstLevel">6. Maintenance</a><br/>
<?php
        }
    }
?>
<br/>

<h3 id="1">1. Introduction</h3>
<p>The Event Management System is a powerful tool that allows you to create and manage Events, Activities, and Roles. The system comes with full front and back end functionality, with Volunteers and SPROUTs able to register and be stored so that they may log in to apply to Roles that Event Managers can post. Not only does the system allow for application to and management of events, but also for Administrative functionality so that you can manage user accounts and many other aspects of the system.
</p>
<h3 id="2">2. Installation</h3>
<p>The minimum requirements to install the system are that the server it is to be hosted on is running apache version 2.4.2 and PHP version 5.4.3 and MySQL version 5.0.10.

    <br/>Apache Install: <a href="http://httpd.apache.org/docs/2.2/install.html">http://httpd.apache.org/docs/2.2/install.html</a>
    <br/>PHP Install: <a href="http://www.w3schools.com/php/php_install.asp">http://www.w3schools.com/php/php_install.asp</a>
    <br/>MySQL Install: <a href="http://dev.mysql.com/doc/refman/5.0/en/installing-cs-overview.html">http://dev.mysql.com/doc/refman/5.0/en/installing-cs-overview.html</a>
    </br>Copy and paste the application into the desired directory.
    </br>The default login is admin@uts.com and password Hello123.
</p>

<h3 id="3">3. Pages</h3>
<h4 id="3.1">3.1. All Users</h4>
<b id="3.1.1">3.1.1. Home Page</b><br/>
<p>The home page will be the first page your users see. It will contain links to pages that are general access, as well as any other information that is desired.</p>
<b id="3.1.2">3.1.2. Timetable Page</b><br/>
<p>The Timetable page will display upcoming events on a calendar and allow users to see the upcoming events for any month they choose. They can then click the event on the calendar and be taken to it to view the details.</p>
<b id="3.1.3">3.1.3. Registration Page</b><br/>
<p>The registration page will allow unregistered guests to create an account with the system so that the system can store their details and allow them to log in and apply to roles. This also allows them to receive emails from the system so they can be kept up to date on upcoming Events.</p>
<b id="3.1.4">3.1.4. Events Page</b><br/>
<p>The Events page can be accessed by all levels of user accounts, displaying all the current and upcoming events that are stored in the system. It will allow users to select an Event and then be taken to the Activities page where the activities for that event will be listed for them.</p>
<b id="3.1.5">3.1.5. Activities Page</b><br/>
<p>The Activities page can be accessed by all levels of user accounts, displaying all the currently available Activities for a specific Event, or all the Activities that are stored in the system if the user directly navigates to the page. It will allow users to select an Activity and then be taken to the Roles page where the Roles for that Activity will be listed for them.</p>
<b id="3.1.6">3.1.6. Roles Page</b><br/>
<p>The Roles page can be accessed by all levels of user accounts, displaying all the currently available Roles for a specific Activity, or all the Roles that are stored in the system if the user directly navigates to the page. It will allow users to select an Activity and then be taken to the Application page if they are logged in, or they will be asked to log in if they aren’t already.</p>
<b id="3.1.7">3.1.7. Mailing List</b><br/>
<p>The mailing list page allows any user to add their email to the mailing list to
    receive emails from the system regarding upcoming events and important announcements.</p>
<b id="3.1.8">3.1.8. Contact Page</b><br/>
<p>The contact page displays all the contact information if the user would like to communicate with your organisation directly.</p>
<h4 id="3.2">3.2. Volunteers, Event Managers, Administrators</h4>
<b id="3.2.1">3.2.1. Application Page</b><br/>
<p>The application page will only be accessible by registered users. the application page will allow Volunteers to apply to the Role that they had selected, with fields for them to enter all the relevant information that is required to apply for a role. Once the user fills in the form, they click the submit button to send their application through for review. If the candidate is successful, the system will email them regarding their successful application.</p>
<b id="3.2.2">3.2.2. Account Dashboard Page (Revise)</b><br/>
<p>The account dashboard will display the currently logged in account’s settings, as well as the roles that have been applied to by the user. This allows the user to navigate to the change settings page so that they can edit the settings of their account.</p>
<b id="3.2.3">3.2.3. Account Information Page</b><br/>
<p>The Account Information page will allow the logged in user to change their details. Things like Phone number, Email address, and postcode will be able to be modified, allowing them to keep their details up to date.</p>
<b id="3.2.4">3.2.4. Change Password Page</b><br/>
<p>The change password page will allow the logged in user to change their password by inputting their current password, then entering and reentering the new password into the required fields.</p>
<b id="3.2.5">3.2.5. University Page</b><br/>
<p>The University Page will allow users to fill out extra information for their user profile. This will allow extra information to be stored so that they have a better chance of successfully applying to and receiving a role.</p>
<b id="3.2.6">3.2.6. Others Page</b><br/>
<p>The Others page will contain optional information about the user account that can be filled in, such as if the use has a drivers license and their availability.</p>
<b id="3.2.7">3.2.7. Applied Page</b><br/>
<p>The Applied page will allow users who have applied to a role in the past to view their past roles, as well as  record hours for currently allocated roles and withdrawing applications for future roles that have been applied to.</p>

<?php
    if($loggedIn){
        if($page->hasAccess())
        {
            
?>
<h4 id="3.3">3.3. Event Managers, Administrators</h4>
<b id="3.3.1">3.3.1. Back-End Events Page</b><br/>
<p>The Back-End Events page will allow Event Managers and Administrators to view all past, current, and future events. It will allow them to create, edit, and delete events.</p>
<b id="3.3.2">3.3.2. Back-End Activities Page</b><br/>
<p>The Back-End Activity page will allow Event Managers and Administrators to view all past, current, and future Activities. It will allow them to create, edit, and delete Activities.</p>
<b id="3.3.3">3.3.3. Back-End Roles Page</b><br/>
<p>The Back-End Roles page will allow Event Managers and Administrators to view all past, current, and future roles. It will allow them to create, edit, and delete Roles.</p>
<b id="3.3.4">3.3.4. Applications Page</b><br/>
<p>The View Volunteer Application page allows Event Managers and Administrators to view the Volunteer Applications for a particular Role. From this page Volunteers can be assigned to Roles, Volunteers can be filtered by skills, as well as modify attendance and hours worked for the Role.</p>
<b id="3.3.5">3.3.5. Add/Remove Volunteer from Role</b><br/>
<p>The page will display a list of volunteers that have applied to the role, with options next to their applications that will allow Event Managers or administrators to add them to the role.</p>
<b id="3.3.6">3.3.6. View Event Report</b><br/>
<p>Generated a report of the selected event. Can only be accessed from the Back-end Event page.</p>
<b id="3.3.7">3.3.7. Account Information</b><br/>
<p>This page allows Admins to create, modify, deactivate, and delete user accounts. Admins can also change the type of an account, promoting and demoting users.</p> 
<b id="3.3.8">3.3.8. Reset Password</b><br/>
<p>This page allows Admins to change the password of a user’s account.</p>
<b id="3.3.9">3.3.9. Back-End University</b><br/>
<p>This page allows an admin to edit the profile of a user’s account</p>
<b id="3.3.10">3.3.10. Back-End Others</b><br/>
<p>This page allows the admin to edit the other information section of a user’s account.</p>
<h3 id="4">4. Function Walkthrough</h3>
<b id="4.1">4.1. Creating events</b><br/>
<ol>
    <li>Navigate to the events page via the Management Portal</li>
    <li>Fill in the details for the Event on the screen.</li>
    <li>Click the submit button to create the event.</li>
</ol>
<b id="4.2">4.2. Creating Activities</b><br/>
<ol>
    <li>Navigate to the activities page via the Management Portal</li>
    <li>Select the Event you would like to create activities for</li>
    <li>Fill in the details for the Event on the screen.</li>
    <li>Click the submit button to create the Activity.</li>
</ol>
<b id="4.3">4.3. Creating Roles</b><br/>
<ol>
    <li>Navigate to the Roles page via the Management Portal</li>
    <li>Select the Event you would like to create activities for</li>
    <li>Fill in the details for the Role on the screen.</li>
    <li>Click the submit button to create the Activity.</li>
</ol>
<b id="4.4">4.4. Creating user accounts (Volunteers, Event Managers, Admins)</b><br/>
<ol>
    <li>Navigate to the Account Information page in the management portal</li>
    <li>Select the create new option and then select the user account to create</li>
    <li>Fill in the form</li>
    <li>Select the account type of the account to be created</li>
    <li>Click the create button</li>
</ol>
<b id="4.5">4.5. Applying to Roles</b><br/>
<ol>
    <li>Navigate to the Events page in the management portal</li>
    <li>Fill in the fields on the Application page</li>
    <li>Click the submit button to finish applying</li>
</ol>
<b id="4.6">4.6. Viewing Applications</b><br/>
<ol>
    <li>Navigate to the applicants page in the management portal</li>
    <li>Select the Event, Activity, and Role you would like to view Volunteer applications for</li>
    <li>The system will load a list of applications for the selected role</li>
    <li>Select the desired applicant from the applicants list</li>
</ol>
<b id="4.7">4.7. Allocating Volunteers to Roles</b><br/>
<ol>
    <li>Navigate to the applicants page</li>
    <li>Select the event, activity, and role you would like to allocate volunteers to.</li>
    <li>Select the volunteer to allocate from the list</li>
    <li>Set the application status to accepted</li>
    <li>Click the update application button</li>
</ol>
<b id="4.8">4.8. De-Allocate Volunteer from Role</b><br/>
<ol>
    <li>Navigate to the applicants page in the management portal</li>
    <li>Select the event, activity, and role you would like to de- allocate volunteers from</li>
    <li>Select the volunteer to de-allocate from the list</li>
    <li>Set the application status to reject</li>
    <li>Click the Update Application button</li>

</ol>
<b id="4.9">4.9. Editing User Accounts</b><br/>
<ol>
    <li>Navigate to the Account Information page in the management portal</li>
    <li>Select the user account you wish to edit</li>
    <li>Edit the information that is loaded</li>
    <li>Click save when all changes are done</li>
</ol>
<b id="4.10">4.10. Deleting User Accounts</b><br/>
<ol>
    <li>Navigate to the Account Information page in the management portal</li>
    <li>Select the user account you wish to delete</li>
    <li>Press the delete button</li>
</ol>
<b id="4.11">4.11. Edit Use Account Type</b><br/>
<ol>
    <li>Navigate to the Account Information page in the management portal</li>
    <li>Select the user account from the drop down list</li>
    <li>Select the account type you would like to change them to from the drop down list</li>
    <li>Click the update button</li>
</ol>
<b id="4.12">4.12. Delete Event</b><br/>
<ol>
    <li>Navigate to the Events page in the management portal</li>
    <li>Select the Event you wish to delete</li>
    <li>Press the delete button</li>
</ol>
<b id="4.13">4.13. Delete Activity</b><br/>
<ol>
    <li>Navigate to the Activities page in the management portal</li>
    <li>Select the Activity you wish to delete</li>
    <li>Press the delete button</li>
</ol>
<b id="4.14">4.14. Delete Role</b><br/>
<ol>
    <li>Navigate to the Roles page in the management portal</li>
    <li>Select the Role you wish to delete</li>
    <li>Press the delete button</li>
</ol>
<b id="4.15">4.15. View Event Report</b><br/>
<ol>
    <li>Navigate to the Events page via the management portal</li>
    <li>Select the Event from the drop down list</li>
    <li>Press the View Report button</li>
</ol>
<h3 id="5">5. Support Documentation</h3>
<h4 id="5.1">5.1. ERD</h4>
<IMG SRC="images/ERD.jpg" ALT="ERD" style="width: 800px"/><br/>
<h4 id="5.2">5.2. Class Diagram</h4>
<IMG SRC="images/ClassDiagram.png" ALT="ERD" style="width:800px"/>
<h3 id="6">6. Maintenance</h3>
</div>


<style type="text/css">.ritz .waffle .s4{text-align:left;color:#000000;background-color:#ffffff;font-size:10pt;vertical-align:top;white-space:normal;overflow:hidden;direction:ltr;padding:2px 3px 2px 3px;}.ritz .waffle .s0{text-align:left;font-weight:bold;color:#ffffff;background-color:#000000;font-size:10pt;vertical-align:bottom;white-space:nowrap;direction:ltr;padding:2px 3px 2px 3px;}.ritz .waffle .s6{border-right: none;text-align:left;color:#ff0000;background-color:#ffffff;font-size:10pt;vertical-align:bottom;white-space:nowrap;direction:ltr;padding:2px 3px 2px 3px;}.ritz .waffle .s1{text-align:left;color:#000000;background-color:#ffffff;font-size:10pt;vertical-align:bottom;white-space:nowrap;direction:ltr;padding:2px 3px 2px 3px;}.ritz .waffle .s2{border-right: none;text-align:left;color:#000000;background-color:#ffffff;font-size:10pt;vertical-align:bottom;white-space:nowrap;direction:ltr;padding:2px 3px 2px 3px;}.ritz .waffle .s3{border-left: none;}.ritz .waffle .s5{text-align:left;color:#ff0000;background-color:#ffffff;font-size:10pt;vertical-align:bottom;white-space:nowrap;direction:ltr;padding:2px 3px 2px 3px;}.ritz .waffle .s7{border-left: none;text-align:left;color:#ff0000;background-color:#ffffff;font-size:10pt;vertical-align:bottom;white-space:nowrap;direction:ltr;padding:2px 3px 2px 3px;}</style><div class="ritz grid-container" dir="ltr"><table class="waffle" cellspacing="0" cellpadding="0"><thead><tr><th class="row-header freezebar-vertical-handle"></th><th id="0C0" style="width:127px" class="column-headers-background">A</th><th id="0C1" style="width:140px" class="column-headers-background">B</th><th id="0C2" style="width:76px" class="column-headers-background">C</th><th id="0C3" style="width:81px" class="column-headers-background">D</th><th id="0C4" style="width:312px" class="column-headers-background">E</th><th id="0C5" style="width:73px" class="column-headers-background">F</th><th id="0C6" style="width:293px" class="column-headers-background">G</th><th id="0C7" style="width:100px" class="column-headers-background">H</th><th id="0C8" style="width:100px" class="column-headers-background">I</th><th id="0C9" style="width:100px" class="column-headers-background">J</th><th id="0C10" style="width:100px" class="column-headers-background">K</th><th id="0C11" style="width:100px" class="column-headers-background">L</th><th id="0C12" style="width:100px" class="column-headers-background">M</th><th id="0C13" style="width:100px" class="column-headers-background">N</th><th id="0C14" style="width:100px" class="column-headers-background">O</th><th id="0C15" style="width:100px" class="column-headers-background">P</th><th id="0C16" style="width:100px" class="column-headers-background">Q</th><th id="0C17" style="width:100px" class="column-headers-background">R</th><th id="0C18" style="width:100px" class="column-headers-background">S</th><th id="0C19" style="width:100px" class="column-headers-background">T</th><th id="0C20" style="width:100px" class="column-headers-background">U</th><th id="0C21" style="width:100px" class="column-headers-background">V</th><th id="0C22" style="width:100px" class="column-headers-background">W</th><th id="0C23" style="width:100px" class="column-headers-background">X</th><th id="0C24" style="width:100px" class="column-headers-background">Y</th><th id="0C25" style="width:100px" class="column-headers-background">Z</th><th id="0C26" style="width:100px" class="column-headers-background">AA</th><th id="0C27" style="width:100px" class="column-headers-background">AB</th></tr></thead><tbody><tr style='height:20px;'><th id="0R0" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">1</div></th><td class="s0" dir="ltr">Table Name</td><td class="s0" dir="ltr">Attribute</td><td class="s0" dir="ltr">Type</td><td class="s0 softmerge" dir="ltr"><div class="softmerge-inner" style="width: 78px; left: -1px;">Max Length</div></td><td class="s0" dir="ltr">Contents</td><td class="s0 softmerge" dir="ltr"><div class="softmerge-inner" style="width: 70px; left: -1px;">Mandatory</div></td><td class="s0" dir="ltr">Comment</td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td><td class="s0"></td></tr><tr><th style="height:3px" class="freezebar-cell freezebar-horizontal-handle"></th><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td><td class="freezebar-cell"></td></tr><tr style='height:20px;'><th id="0R1" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">2</div></th><td class="s1" dir="ltr">PERSON</td><td class="s1" dir="ltr">PersonID*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Primary Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R2" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">3</div></th><td></td><td class="s1" dir="ltr">FirstName</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">35</td><td class="s1" dir="ltr">Alphabetic, plus hyphen and single quote</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R3" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">4</div></th><td></td><td class="s1" dir="ltr">LastName</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">35</td><td class="s1" dir="ltr">Alphabetic, plus hyphen and single quote</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R4" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">5</div></th><td></td><td class="s1" dir="ltr">ContactNumber</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">10</td><td class="s1" dir="ltr">Numeric</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R5" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">6</div></th><td></td><td class="s1" dir="ltr">Gender</td><td class="s1" dir="ltr">enum</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">M, F or U</td><td class="s1" dir="ltr">Yes</td><td class="s2 softmerge" dir="ltr"><div class="softmerge-inner" style="width: 391px; left: -1px;">Volunteers are allowed to not specify a gender</div></td><td class="s3"></td><td class="s3"></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R6" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">7</div></th><td></td><td class="s1" dir="ltr">Password</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">255</td><td class="s1 softmerge" dir="ltr"><div class="softmerge-inner" style="width: 309px; left: -1px;">Min 1 capital char, min 1 numeric char, alphanumeric</div></td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R7" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">8</div></th><td></td><td class="s1" dir="ltr">Salt</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">2</td><td class="s1" dir="ltr">Numeric Randomly Generated</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R8" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">9</div></th><td></td><td class="s1" dir="ltr">Email</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">80</td><td class="s1" dir="ltr">A-Z a-z 0-9 !#$%&amp;&#39;*+-/=?^_`{|}~.</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R9" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">10</div></th><td></td><td class="s1" dir="ltr">UniversityID</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Numeric</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R10" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">11</div></th><td></td><td class="s1" dir="ltr">DegreeName</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">100</td><td class="s1" dir="ltr">Alphabetic, plus hyphen</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R11" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">12</div></th><td></td><td class="s1" dir="ltr">Majors</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">255</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R12" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">13</div></th><td></td><td class="s1" dir="ltr">YearOfDegree</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">1</td><td class="s1" dir="ltr">Numeric</td><td class="s1" dir="ltr">No</td><td class="s2 softmerge" dir="ltr"><div class="softmerge-inner" style="width: 391px; left: -1px;">Or equivilant if completing university part time</div></td><td class="s3"></td><td class="s3"></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R13" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">14</div></th><td></td><td class="s1" dir="ltr">Avaliability</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">255</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr"></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R14" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">15</div></th><td></td><td class="s1" dir="ltr">DriversLicence</td><td class="s1" dir="ltr">boolean</td><td class="s1" dir="ltr">1</td><td class="s1" dir="ltr">true/false</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R15" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">16</div></th><td></td><td class="s1" dir="ltr">HighSchool</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">100</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R16" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">17</div></th><td></td><td class="s1" dir="ltr">EntryToUTS</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">100</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R17" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">18</div></th><td></td><td class="s1" dir="ltr">PreviousInterships</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">255</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:19px;'><th id="0R18" style="height: 19px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 19px;">19</div></th><td></td><td class="s4" dir="ltr">ExtraCirricularActivities</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">255</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R19" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">20</div></th><td></td><td class="s1" dir="ltr">Scholarships</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">255</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R20" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">21</div></th><td></td><td class="s1" dir="ltr">PaperworkStatus</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">255</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr">May be changed to enum</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R21" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">22</div></th><td></td><td class="s1" dir="ltr">IntershipOrganised</td><td class="s1" dir="ltr">boolean</td><td class="s1" dir="ltr">1</td><td class="s1" dir="ltr">true/false</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R22" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">23</div></th><td></td><td class="s1" dir="ltr">Workshops</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">255</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R23" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">24</div></th><td></td><td class="s1" dir="ltr">Refugee</td><td class="s1" dir="ltr">boolean</td><td class="s1" dir="ltr">1</td><td class="s1" dir="ltr">true/false</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R24" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">25</div></th><td></td><td class="s1" dir="ltr">Indigenous</td><td class="s1" dir="ltr">boolean</td><td class="s1" dir="ltr">1</td><td class="s1" dir="ltr">true/false</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R25" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">26</div></th><td></td><td class="s1" dir="ltr">Address</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">100</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R26" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">27</div></th><td></td><td class="s1" dir="ltr">ContractExpiration</td><td class="s1" dir="ltr">date</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">YYYY-MM-DD</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R27" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">28</div></th><td></td><td class="s1" dir="ltr">Offer</td><td class="s1" dir="ltr">boolean</td><td class="s1" dir="ltr">1</td><td class="s1" dir="ltr">true/false</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R28" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">29</div></th><td></td><td class="s1" dir="ltr">Activated</td><td class="s1" dir="ltr">boolean</td><td class="s1" dir="ltr">1</td><td class="s1" dir="ltr">Boolean</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R29" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">30</div></th><td></td><td class="s1" dir="ltr">AccountType</td><td class="s1" dir="ltr">enum</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">admin, eventmanager, sprout, volunteer</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">There are only 4 categories of people stored</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R30" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">31</div></th><td></td><td class="s1" dir="ltr">ResetKey</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">32</td><td class="s1" dir="ltr">alphanumeric</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Used to reset password</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R31" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">32</div></th><td></td><td class="s1" dir="ltr">ActivationKey</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">32</td><td class="s1" dir="ltr">alphanumeric</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Used to activate account</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R32" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">33</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R33" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">34</div></th><td class="s5"></td><td class="s5" dir="ltr">Skills</td><td class="s5" dir="ltr">varchar</td><td class="s5" dir="ltr">255</td><td class="s5" dir="ltr">Any character</td><td class="s5" dir="ltr">No</td><td class="s6 softmerge" dir="ltr"><div class="softmerge-inner" style="width: 391px; left: -1px;">Temporary field unil entity skills are implemented</div></td><td class="s7"></td><td class="s7"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td></tr><tr style='height:20px;'><th id="0R34" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">35</div></th><td class="s1" dir="ltr">DOCUMENTATION</td><td class="s1" dir="ltr">DocumentID*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Primary Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R35" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">36</div></th><td></td><td class="s1" dir="ltr">Person</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Person foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R36" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">37</div></th><td></td><td class="s1" dir="ltr">File</td><td class="s1 softmerge" dir="ltr"><div class="softmerge-inner" style="width: 73px; left: -1px;">mediumblob</div></td><td class="s1" dir="ltr">16MB</td><td class="s1" dir="ltr">Binary file</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R37" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">38</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R38" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">39</div></th><td class="s1" dir="ltr">PERSON_SKILLS</td><td class="s1" dir="ltr">Person*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Person primary key, foreign key</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">If volunteer skill proof is required</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R39" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">40</div></th><td class="s1" dir="ltr"></td><td class="s1" dir="ltr">Skill*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Skill primary key, foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R40" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">41</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R41" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">42</div></th><td class="s1" dir="ltr">SKILLS</td><td class="s1" dir="ltr">SkillID*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Primary Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R42" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">43</div></th><td></td><td class="s1" dir="ltr">Title</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">30</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R43" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">44</div></th><td></td><td class="s1" dir="ltr">Description</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">300</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R44" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">45</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R45" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">46</div></th><td class="s1" dir="ltr">ROLE_SKILLS</td><td class="s1" dir="ltr">Role*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Role primary key, foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R46" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">47</div></th><td></td><td class="s1" dir="ltr">Skill*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Skill primary key, foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R47" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">48</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R48" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">49</div></th><td class="s1" dir="ltr">ROLE</td><td class="s1" dir="ltr">RoleID*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Primary Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R49" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">50</div></th><td></td><td class="s1" dir="ltr">Title</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">30</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R50" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">51</div></th><td></td><td class="s1" dir="ltr">Description</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">300</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R51" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">52</div></th><td></td><td class="s1" dir="ltr">PayRate</td><td class="s1" dir="ltr">float</td><td class="s1" dir="ltr">10</td><td class="s1" dir="ltr">Numeric Decimal</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R52" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">53</div></th><td></td><td class="s1" dir="ltr">Potitions</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">2</td><td class="s1" dir="ltr">Integer</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Positions avaliable</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R53" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">54</div></th><td></td><td class="s1" dir="ltr">StartTime</td><td class="s1" dir="ltr">time</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">HH:MM:SS</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R54" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">55</div></th><td></td><td class="s1" dir="ltr">EndTime</td><td class="s1" dir="ltr">time</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">HH:MM:SS</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R55" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">56</div></th><td></td><td class="s1" dir="ltr">StartDate</td><td class="s1" dir="ltr">date</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">YYYY-MM-DD</td><td class="s1" dir="ltr">No</td><td class="s2 softmerge" dir="ltr"><div class="softmerge-inner" style="width: 391px; left: -1px;">Only requried if different from event or activity date</div></td><td class="s3"></td><td class="s3"></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R56" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">57</div></th><td></td><td class="s1" dir="ltr">EndDate</td><td class="s1" dir="ltr">date</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">YYYY-MM-DD</td><td class="s1" dir="ltr">No</td><td class="s2 softmerge" dir="ltr"><div class="softmerge-inner" style="width: 391px; left: -1px;">Only requried if different from event or activity date</div></td><td class="s3"></td><td class="s3"></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R57" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">58</div></th><td></td><td class="s1" dir="ltr">ActivityID</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Activity foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R58" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">59</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R59" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">60</div></th><td class="s5"></td><td class="s5" dir="ltr">Skills</td><td class="s5" dir="ltr">varchar</td><td class="s5" dir="ltr">255</td><td class="s5" dir="ltr">Any character</td><td class="s5" dir="ltr">No</td><td class="s6 softmerge" dir="ltr"><div class="softmerge-inner" style="width: 391px; left: -1px;">Temporary field unil entity skills are implemented</div></td><td class="s7"></td><td class="s7"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td><td class="s5"></td></tr><tr style='height:20px;'><th id="0R60" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">61</div></th><td class="s1" dir="ltr">ACTIVITY</td><td class="s1" dir="ltr">ActivityID*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Primary Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R61" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">62</div></th><td></td><td class="s1" dir="ltr">Title</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">30</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R62" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">63</div></th><td></td><td class="s1" dir="ltr">Description</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">300</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R63" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">64</div></th><td></td><td class="s1" dir="ltr">StartTime</td><td class="s1" dir="ltr">time</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">HH:MM:SS</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr">Only requried if different from event time</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R64" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">65</div></th><td></td><td class="s1" dir="ltr">EndTime</td><td class="s1" dir="ltr">time</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">HH:MM:SS</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr">Only requried if different from event time</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R65" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">66</div></th><td></td><td class="s1" dir="ltr">StartDate</td><td class="s1" dir="ltr">date</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">YYYY-MM-DD</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr">Only requried if different from event date</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R66" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">67</div></th><td></td><td class="s1" dir="ltr">EndDate</td><td class="s1" dir="ltr">date</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">YYYY-MM-DD</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr">Only requried if different from event date</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R67" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">68</div></th><td></td><td class="s1" dir="ltr">Event</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Event foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R68" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">69</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R69" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">70</div></th><td class="s1" dir="ltr">EVENT</td><td class="s1" dir="ltr">EventID*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Primary Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R70" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">71</div></th><td></td><td class="s1" dir="ltr">Name</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">30</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R71" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">72</div></th><td></td><td class="s1" dir="ltr">Description</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">300</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R72" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">73</div></th><td></td><td class="s1" dir="ltr">StartTime</td><td class="s1" dir="ltr">time</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">HH:MM:SS</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R73" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">74</div></th><td></td><td class="s1" dir="ltr">EndTime</td><td class="s1" dir="ltr">time</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">HH:MM:SS</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R74" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">75</div></th><td></td><td class="s1" dir="ltr">StartDate</td><td class="s1" dir="ltr">date</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">YYYY-MM-DD</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R75" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">76</div></th><td></td><td class="s1" dir="ltr">EndDate</td><td class="s1" dir="ltr">date</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">YYYY-MM-DD</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R76" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">77</div></th><td></td><td class="s1" dir="ltr">LocationDetails</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">100</td><td class="s1" dir="ltr">Address of event</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R77" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">78</div></th><td></td><td class="s1" dir="ltr">CarPoolTime</td><td class="s1" dir="ltr">time</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">HH:MM:SS</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R78" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">79</div></th><td></td><td class="s1" dir="ltr">CarPoolLocation</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">100</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R79" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">80</div></th><td></td><td class="s1" dir="ltr">MeetingLocation</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">100</td><td class="s1" dir="ltr">Address</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr">Carpool meeting location</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R80" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">81</div></th><td></td><td class="s1" dir="ltr">MeetingTime</td><td class="s1" dir="ltr">time</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">HH:MM:SS</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr">Carpool meeting time</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R81" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">82</div></th><td></td><td class="s1" dir="ltr">EventPicture</td><td class="s1 softmerge" dir="ltr"><div class="softmerge-inner" style="width: 73px; left: -1px;">mediumblob</div></td><td class="s1" dir="ltr">16MB</td><td class="s1" dir="ltr">File</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr">Optional event picture</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R82" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">83</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R83" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">84</div></th><td class="s1" dir="ltr">MANAGES</td><td class="s1" dir="ltr">Event*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Event primary key, foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R84" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">85</div></th><td></td><td class="s1" dir="ltr">Person*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Person primary key, foreign key</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Events can have up to 5 managers</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R85" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">86</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R86" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">87</div></th><td class="s1" dir="ltr">APPLIED</td><td class="s1" dir="ltr">Person*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Person primary key, foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R87" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">88</div></th><td></td><td class="s1" dir="ltr">Role*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Role primary key, foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R88" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">89</div></th><td></td><td class="s1" dir="ltr">Accepted</td><td class="s1" dir="ltr">enum</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">pending,rejected,accepted</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">value changed by event manager</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R89" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">90</div></th><td></td><td class="s1" dir="ltr">Attented</td><td class="s1" dir="ltr">boolean</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">boolean</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R90" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">91</div></th><td></td><td class="s1" dir="ltr">HoursWorked</td><td class="s1" dir="ltr">float</td><td class="s1" dir="ltr">5</td><td class="s1" dir="ltr">Numeric decimal</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R91" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">92</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R92" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">93</div></th><td class="s1" dir="ltr">EQUIPMENT</td><td class="s1" dir="ltr">EquipmentID*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Primary Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R93" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">94</div></th><td></td><td class="s1" dir="ltr">Event</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Event foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R94" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">95</div></th><td class="s1"></td><td class="s1">Title</td><td class="s1" dir="ltr">varchar</td><td class="s1">30 chars</td><td class="s1" dir="ltr">Any character</td><td class="s1">Yes</td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td></tr><tr style='height:20px;'><th id="0R95" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">96</div></th><td></td><td class="s1" dir="ltr">Booked</td><td class="s1" dir="ltr">boolean</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Boolean</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R96" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">97</div></th><td></td><td class="s1" dir="ltr">OrganisedBy</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Person foreign key</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R97" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">98</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R98" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">99</div></th><td class="s1" dir="ltr">TODO_LIST</td><td class="s1" dir="ltr">TodoID*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Primary Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R99" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">100</div></th><td></td><td class="s1" dir="ltr">Event</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Event foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R100" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">101</div></th><td></td><td class="s1" dir="ltr">TaskDescription</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">300</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R101" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">102</div></th><td></td><td class="s1" dir="ltr">ExpectedBy</td><td class="s1" dir="ltr">date</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">YYYY-MM-DD</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr">Can be task to complete before or after event</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R102" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">103</div></th><td></td><td class="s1" dir="ltr">Completed</td><td class="s1" dir="ltr">boolean</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Boolean</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R103" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">104</div></th><td></td><td class="s1" dir="ltr">AssignedTo</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Person foreign key</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr">A task can be assigned if needed</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R104" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">105</div></th><td></td><td class="s1" dir="ltr">CompletedBy</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Person foreign key</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr">Can be useful for a task follow up</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R105" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">106</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R106" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">107</div></th><td class="s1" dir="ltr">EVENT_FEEDBACK</td><td class="s1" dir="ltr">Event*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Event primary key, foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R107" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">108</div></th><td></td><td class="s1" dir="ltr">Feedback*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Feedback primary key, foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R108" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">109</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R109" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">110</div></th><td class="s1" dir="ltr">FEEDBACK</td><td class="s1" dir="ltr">FeedbackID*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Primary Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R110" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">111</div></th><td class="s1"></td><td class="s1">Title</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">30</td><td class="s1" dir="ltr">Any character</td><td class="s1">Yes</td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td><td class="s1"></td></tr><tr style='height:20px;'><th id="0R111" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">112</div></th><td></td><td class="s1" dir="ltr">Creator</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Person foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R112" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">113</div></th><td></td><td class="s1" dir="ltr">AnonymousForm</td><td class="s1" dir="ltr">boolean</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Boolean</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R113" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">114</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R114" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">115</div></th><td class="s1" dir="ltr">QUESTION</td><td class="s1" dir="ltr">QuestionID*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Primary Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R115" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">116</div></th><td></td><td class="s1" dir="ltr">FeedbackForm</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Feedback foreign Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R116" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">117</div></th><td></td><td class="s1" dir="ltr">Question</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">100</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">100 characters per question</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R117" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">118</div></th><td></td><td class="s1" dir="ltr">AnswerType</td><td class="s1" dir="ltr">enum</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">input, select, checkbox</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R118" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">119</div></th><td></td><td class="s1" dir="ltr">MaxLength</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">3</td><td class="s1" dir="ltr">Numeric</td><td class="s1" dir="ltr">Yes</td><td class="s2 softmerge" dir="ltr"><div class="softmerge-inner" style="width: 391px; left: -1px;">If there is a maximum length for a input question</div></td><td class="s3"></td><td class="s3"></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R119" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">120</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R120" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">121</div></th><td class="s1" dir="ltr">ANSWER</td><td class="s1" dir="ltr">AnswerID*</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Primary Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R121" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">122</div></th><td></td><td class="s1" dir="ltr">Question</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Question foreign key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R122" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">123</div></th><td></td><td class="s1" dir="ltr">Person</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Person foreign key</td><td class="s1" dir="ltr">No</td><td class="s1" dir="ltr">Not required if anonymous</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R123" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">124</div></th><td></td><td class="s1" dir="ltr">Answer</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">512</td><td class="s1" dir="ltr">Any character</td><td class="s1" dir="ltr">No</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R124" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">125</div></th><td></td><td class="s1" dir="ltr">DateCreated</td><td class="s1" dir="ltr">timestamp</td><td class="s1" dir="ltr">-</td><td class="s1" dir="ltr">Timestamp</td><td class="s1" dir="ltr">Yes</td><td class="s1" dir="ltr">Auto-generated with row</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R125" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">126</div></th><td></td><td></td><td></td><td class="s1"></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R126" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">127</div></th><td class="s1" dir="ltr">MAILING_LIST</td><td class="s1" dir="ltr">EmailID</td><td class="s1" dir="ltr">integer</td><td class="s1" dir="ltr">8</td><td class="s1" dir="ltr">Primary Key</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr style='height:20px;'><th id="0R127" style="height: 20px;" class="row-headers-background"><div class="row-header-wrapper" style="line-height: 20px;">128</div></th><td></td><td class="s1" dir="ltr">Email</td><td class="s1" dir="ltr">varchar</td><td class="s1" dir="ltr">80</td><td class="s1" dir="ltr">A-Z a-z 0-9 !#$%&amp;&#39;*+-/=?^_`{|}~.</td><td class="s1" dir="ltr">Yes</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table></div>
<?php
        }
        else{
            echo "</div>";
        }
    }
    else{
        echo "</div>";
    }
  
 ?>
<?php include_once("footer.php"); ?>